CMFCSD Salaries Stats

CAUTION There are three kinds of lies: lies, damned lies, and statistics. (C) someone
In [1]:
import cufflinks as cf
import pandas as pd
import numpy as np

import plotly.offline as py
import plotly.graph_objs as go

from IPython.display import display, Markdown, Latex

py.init_notebook_mode(connected=True)

cf.set_config_file(offline=True)
In [2]:
dtype = {'County': np.str,
         'Employee Name': np.str,
         'Job Title': np.str,
         'Year': np.int64,
         'Notes': np.str,
         'Agency': np.str,
         'Status': np.str}


def to_float(x):
    try:
        return float(x)
    except Exception as e:
        return None


converters = {'Base Pay': to_float,
              'Overtime Pay': to_float,
              'Other Pay': to_float,
              'Benefits': to_float,
              'Total Pay': to_float,
              'Total Pay & Benefits': to_float}

df = pd.read_csv("data.csv.gz", compression='gzip', dtype=dtype, converters=converters)
In [5]:
ENTITIES_MAPPING = {
    'Teachers': 'teacher',
    'Managers': 'principal|director|chief|intendent'
}
ENTITIES = ['Teachers', 'Managers']
YEARS = [2016, 2015, 2014, 2013, 2012]
COUNTIES = ['San Mateo County']

def get_df(county, entity, year):
    return df[(df['County'] == county) & 
              (df['Job Title'].str.contains("(?i){entity}".format(entity=ENTITIES_MAPPING[entity]))) & 
              (df['Year'] == year)] 

def display_mean_salary_by_year(county, entity, year):
    ga = get_df(county, entity, year).groupby(['Agency'])['Total Pay & Benefits']
    ga_mean = ga.mean()
    ga_mean = ga_mean.to_frame().reset_index().sort_values(by='Total Pay & Benefits', ascending=False)
    
   
    bar = go.Bar(x=ga_mean['Agency'],
                 y=ga_mean['Total Pay & Benefits'],
                 marker=dict(color=np.where(ga_mean['Agency'] == 'San Mateo-Foster City', 'rgba(222,45,38,0.8)', 'rgba(204,204,204,1)').tolist()))
    layout = go.Layout(
        margin=go.Margin(
            l=60,
            r=50,
            b=150,
            t=100,
            pad=2
        ),
        title='{county}, {entity}, Mean Salary - {year}'.format(county=county, 
                                                                entity=entity, 
                                                                year=year),
        xaxis=dict(
            title='Agency',
            tickfont=dict(
                size=14,
                color='rgb(107, 107, 107)'
            )
        ),
        yaxis=dict(
            title='Mean Salary (USD)',
            titlefont=dict(
                size=16,
                color='rgb(107, 107, 107)'
            ),
            tickfont=dict(
                size=14,
                color='rgb(107, 107, 107)'
            )
        )
    )
    fig = go.Figure(data=[bar], layout=layout)
    py.offline.iplot(fig, filename='basic-bar')
    
    """    
    ga_mean.iplot(title='{county}, {entity}, Mean Salary - {year}'.format(county=county, 
                                                                          entity=entity, 
                                                                          year=year), 
                  x='Agency', kind='bar', filename='cufflinks/grouped-bar-chart',
                  xTitle='Agencies', yTitle='Mean Salary', colors={'Agency': 'red', 'Total Pay & Benefits': 'black'})
    """
    
    # print table under graph
    display(ga.describe().sort_values(by='mean', ascending=False))

for county in COUNTIES:
    for k in ENTITIES:
        display(Markdown('# {county}, {entity}, Mean Salary in {year_from} - {year_to}'.format(county=county,
                                                                                             entity=k,
                                                                                             year_from=min(YEARS),
                                                                                             year_to=max(YEARS))))
        for year in YEARS:
            display_mean_salary_by_year(county, k, year)           

San Mateo County, Teachers, Mean Salary in 2012 - 2016

count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 51.0 114308.219020 35249.918013 24441.29 103155.8500 121072.10 141348.2650 155939.98
Las Lomitas Elementary 86.0 112186.286860 34589.274925 17674.21 101644.4400 124789.11 135003.1050 162679.42
Menlo Park City Elementary 197.0 109100.831675 31872.646527 4772.96 93540.9600 120378.59 132307.0000 149728.85
San Mateo Union High 516.0 89637.898624 55348.637580 0.00 43487.9725 110342.98 136326.1075 177103.02
Redwood City Elementary 414.0 84091.860145 30399.758222 3467.76 66821.5800 90014.50 108050.1200 130262.17
San Mateo County Office of Education 98.0 81386.744898 51924.932731 161.00 34584.7500 87253.00 130387.5000 162407.00
San Mateo-Foster City 671.0 80915.340134 34628.192956 0.00 56369.8450 88089.60 109455.3500 130813.29
San Carlos Elementary 179.0 80820.370000 30054.581153 10515.54 62665.3750 93103.93 101742.9000 118654.71
Belmont-Redwood Shores Elementary 212.0 80434.726415 30277.630425 1.00 63843.0000 84095.00 104613.7500 141135.00
Pacifica School District 166.0 78638.991265 31585.521205 0.00 56373.2525 88943.20 105053.9350 126200.80
South San Francisco Unified 361.0 76595.146814 26264.206634 0.00 65551.0000 79782.00 96918.0000 127910.00
Burlingame Elementary 184.0 74049.296196 27328.244889 4156.15 54526.6300 77799.64 96986.4500 116783.89
Bayshore Elementary 23.0 71390.652174 24179.923018 23153.00 64017.0000 76141.00 85656.5000 102482.00
La Honda-Pescadero Unified 38.0 66914.996579 30181.638608 24.70 47218.5150 72050.93 87400.4625 124795.88
count mean std min 25% 50% 75% max
Agency
San Mateo Union High 388.0 117053.419407 38169.116191 1199.06 97240.6825 129096.210 146170.9600 195573.51
Menlo Park City Elementary 210.0 106634.159810 38686.061510 1314.29 85142.0375 121874.850 136013.6300 152600.47
Woodside Elementary 39.0 105741.350000 32786.614038 35032.81 85672.0350 115348.250 127850.4250 165303.09
Hillsborough City Elementary 135.0 105162.210370 36274.898210 14200.68 82639.9600 117400.880 132841.8800 156858.61
San Carlos Elementary 180.0 83407.442056 27958.945131 466.41 71778.0475 93333.765 103788.5975 120869.68
San Mateo-Foster City 629.0 83212.395008 29649.920508 0.00 66751.6200 90426.970 106376.2700 130413.40
Cabrillo Unified 184.0 81777.165978 34833.832782 881.28 62324.3800 85248.490 110965.5075 151335.71
South San Francisco Unified 462.0 79156.752078 26248.529575 7958.79 66955.5950 84441.055 100269.8175 134160.62
Jefferson Elementary 352.0 78553.438267 29733.544352 1159.30 62450.7850 85683.545 101899.6775 130453.74
Las Lomitas Elementary 147.0 76413.640408 60059.383481 0.00 5274.0450 96178.840 131790.1800 164809.81
Pacifica School District 167.0 74941.960838 32807.893235 279.69 44251.4650 84648.410 102492.5250 124831.43
Millbrae Elementary 145.0 72698.632207 31377.970924 1219.43 42626.0000 78673.190 100827.2700 122979.02
La Honda-Pescadero Unified 37.0 72450.631351 33348.148371 66.35 60311.7900 80146.950 92991.6200 129516.80
Belmont-Redwood Shores Elementary 293.0 62663.578669 44117.376622 75.50 17713.8200 70308.950 101781.4100 138947.88
Redwood City Elementary 683.0 58250.725256 40445.781841 0.00 18701.5100 59961.680 97720.3450 127244.90
Bayshore Elementary 26.0 57759.400769 28857.414005 3612.80 34075.6750 65248.930 75227.9475 103615.24
Burlingame Elementary 289.0 52548.259758 39689.071425 0.00 10129.9100 52903.210 91831.6400 115200.73
count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 52.0 105835.640962 37843.494669 19043.07 84528.1450 118646.980 136825.6275 150799.05
San Mateo Union High 416.0 103967.956082 39288.931495 0.00 79755.1200 116578.340 134148.1225 174815.47
Menlo Park City Elementary 186.0 100413.679355 29965.087940 11063.51 84839.6175 111633.745 122127.9225 155511.51
Hillsborough City Elementary 121.0 100334.018099 32384.399559 2340.89 84872.4300 112626.720 124116.3900 143246.43
San Mateo County Office of Education 103.0 87739.738835 39363.815048 395.31 66196.7950 107152.760 119103.0500 136965.99
Jefferson Elementary 332.0 76217.283343 25110.283448 3763.12 63432.5300 82794.685 95520.4375 119883.27
Belmont-Redwood Shores Elementary 217.0 74392.099355 30452.177747 3774.79 49936.4900 80745.930 100871.8900 126241.04
Redwood City Elementary 495.0 74273.028343 30093.956590 351.67 48675.1450 77395.720 99867.0950 121788.88
Brisbane Elementary 37.0 73454.801081 28064.801734 11053.65 50678.8100 85438.750 94788.6700 118708.63
Pacifica School District 165.0 73329.545758 31912.636493 678.11 44900.9200 83471.820 100356.1400 121840.67
Ravenswood City Elementary 197.0 71128.684619 25138.881238 0.00 56524.6700 73807.540 88427.7300 115228.80
Millbrae Elementary 139.0 71015.978201 30785.372272 17.22 46388.6500 78047.890 96976.9750 119780.36
Las Lomitas Elementary 148.0 69855.697703 53580.997176 160.59 7628.1150 78512.025 120401.0125 150214.89
San Carlos Elementary 166.0 67331.713735 20636.466296 7099.70 56748.8775 72876.010 81953.3250 92283.37
Jefferson Union High 307.0 67162.868013 36646.405483 787.85 36045.0050 73695.530 96644.9100 139596.81
San Bruno Park Elementary 127.0 67075.628976 22418.212869 10196.68 54798.2050 72355.320 83035.3600 102585.78
San Mateo-Foster City 689.0 66616.075849 39514.742097 0.00 29700.6700 74407.940 98813.2800 146467.25
La Honda-Pescadero Unified 39.0 65014.450000 30052.891996 12498.98 37932.8850 63799.980 91097.8600 111784.48
Burlingame Elementary 300.0 47605.959067 39188.397976 66.00 3930.7500 47564.800 84949.2275 109924.81
count mean std min 25% 50% 75% max
Agency
San Mateo Union High 438.0 106746.377466 32364.589033 6441.78 91408.7975 118055.935 130396.8425 168120.68
Menlo Park City Elementary 185.0 105104.414703 30059.186691 24090.59 94554.8200 115788.830 126987.8800 153199.80
Portola Valley Elementary 51.0 100642.726078 32682.519865 27403.30 83698.2400 111475.080 127329.1850 142243.51
Woodside Elementary 42.0 91489.523333 35015.897871 27239.60 61736.5725 105456.310 119330.6000 153219.27
Sequoia Union High 561.0 90095.171961 42362.880521 137.12 53709.9600 103786.260 125135.6000 156745.76
San Mateo County Office of Education 107.0 86761.852991 43038.564355 172.39 46162.7700 108267.940 119327.4400 136325.97
Brisbane Elementary 31.0 77818.666774 18070.359894 18839.57 71261.1650 81433.830 87380.9600 105451.17
San Carlos Elementary 161.0 76820.162298 25046.030843 10598.42 63564.8700 82375.410 97196.7100 112622.01
Redwood City Elementary 449.0 75288.017951 25819.079886 1834.92 60152.6300 81916.510 96344.2400 116783.84
Cabrillo Unified 183.0 75205.049508 36026.067850 110.00 49244.5700 87243.610 104155.5400 142403.74
Belmont-Redwood Shores Elementary 205.0 73109.070537 30021.014470 2665.76 59466.5200 80115.690 97904.8800 123762.26
Jefferson Elementary 305.0 71644.482197 21574.008981 4925.83 58902.8600 77942.150 88039.2900 109289.78
San Mateo-Foster City 602.0 71214.452957 26121.344440 583.81 57438.8500 77823.610 91047.5850 112736.83
Las Lomitas Elementary 143.0 70782.838811 54023.507918 95.44 7836.5850 81882.300 122727.0400 152121.77
South San Francisco Unified 468.0 70256.048098 24695.864975 958.73 60398.0325 75477.730 89180.5775 122537.33
Pacifica School District 161.0 70103.760311 28779.303537 4844.49 53541.3900 78631.270 93947.8200 114053.43
Millbrae Elementary 126.0 69823.920714 27954.430841 5995.26 52522.7425 79981.635 94162.4125 112745.96
Burlingame Elementary 174.0 68961.492241 26729.159614 16394.88 46036.7975 74302.805 91756.5450 112808.86
Ravenswood City Elementary 213.0 65991.920563 26802.787115 2211.88 41526.0000 71886.560 85880.9700 111852.33
Hillsborough City Elementary 200.0 57354.300750 48936.884226 67.50 2530.3700 55736.105 108284.9700 140377.22
Jefferson Union High 320.0 55105.377406 37056.504768 3.64 16885.6475 64265.885 86367.0700 125814.87
La Honda-Pescadero Unified 42.0 51679.879524 30051.522997 1745.12 26156.1975 53969.835 74093.1175 108244.30
Bayshore Elementary 33.0 39379.459394 31633.674839 135.31 5022.8000 33913.540 63776.9000 97785.69
count mean std min 25% 50% 75% max
Agency
Redwood City Elementary 1.0 106291.190000 NaN 106291.19 106291.1900 106291.190 106291.1900 106291.19
Portola Valley Elementary 51.0 103730.362745 36416.987905 12196.40 82261.1500 116476.300 131327.4600 147461.64
San Mateo Union High 448.0 102353.300915 32984.911957 219.40 85361.6225 114449.705 126636.8550 161873.28
Menlo Park City Elementary 175.0 98317.483029 27246.940768 16259.12 86321.9850 107683.840 118193.4350 138092.83
Sequoia Union High 463.0 97190.923866 31663.120873 2369.70 76728.0050 106057.000 121067.1750 152706.34
San Mateo County Office of Education 107.0 82472.189626 39042.438816 1442.17 61257.5350 101141.140 112090.6600 125511.89
Belmont-Redwood Shores Elementary 192.0 75600.078854 29794.200287 389.37 61106.5650 82535.865 100154.5525 120567.44
Millbrae Elementary 118.0 73237.939492 25669.150838 1129.65 59877.6925 82400.920 93143.4775 110617.36
South San Francisco Unified 475.0 71240.390589 23378.121732 3571.38 61071.0700 75791.690 89006.5850 123700.60
Jefferson Elementary 294.0 70895.214456 20457.987967 8.75 59641.2225 76396.025 86299.9850 104356.13
Pacifica School District 1.0 68010.680000 NaN 68010.68 68010.6800 68010.680 68010.6800 68010.68
Burlingame Elementary 168.0 67966.885774 23658.297316 124.49 52334.5025 72235.185 88342.0475 105432.58
Las Lomitas Elementary 140.0 66225.797357 52224.619640 121.74 4074.0750 76045.210 117819.3975 143552.72
San Mateo-Foster City 582.0 65746.562835 24875.457653 5265.89 47096.5850 72331.055 86252.9600 104866.65
Jefferson Union High 254.0 64031.084449 23561.854697 22.25 50859.1050 67971.275 81681.2000 121476.34
Ravenswood City Elementary 212.0 58770.823774 25177.607995 154.22 36492.7050 65393.615 77108.3975 100902.64
Hillsborough City Elementary 197.0 57593.772893 48096.593626 60.00 2617.6000 65825.390 106352.1000 136499.81
Woodside Elementary 69.0 56385.008116 49752.682222 159.06 2505.8000 57991.670 104225.3000 145463.08
San Carlos Elementary 229.0 56255.927991 39349.962461 43.71 9461.0900 68216.610 91471.2100 114395.08
La Honda-Pescadero Unified 37.0 53344.679459 27025.285021 2578.48 31291.4900 61565.280 70151.4500 97885.36
Bayshore Elementary 30.0 39795.116667 31961.471661 125.00 2765.6250 49401.620 65832.0200 95778.24

San Mateo County, Managers, Mean Salary in 2012 - 2016

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 31.0 188238.368065 57809.139589 71660.30 171328.4550 187869.990 214945.4950 348435.74
Portola Valley Elementary 7.0 180136.747143 65742.967750 42479.98 182593.2400 187974.570 209274.5200 246767.16
Menlo Park City Elementary 16.0 179321.708750 34523.250819 140584.95 148191.7525 178038.995 198997.2975 274717.64
San Mateo-Foster City 41.0 166990.780976 46817.764106 43060.05 160921.6300 185196.750 192755.1100 270074.32
Burlingame Elementary 16.0 162261.766875 40885.781441 111612.22 141249.7425 153092.375 175045.0625 293857.48
San Mateo County Office of Education 19.0 156921.000000 69794.492170 307.00 137576.5000 167977.000 194805.5000 272407.00
Las Lomitas Elementary 12.0 151795.771667 51351.003733 64856.23 120715.8400 162376.710 178368.5250 248142.92
Belmont-Redwood Shores Elementary 16.0 147806.937500 38699.798546 78340.00 123041.0000 149778.500 167874.0000 234988.00
Pacifica School District 17.0 146165.937647 53597.249382 14546.44 131817.6500 150180.960 162938.2900 248636.70
Redwood City Elementary 42.0 145462.825000 41731.426639 64276.06 131574.0425 151397.195 168140.6250 268113.54
San Carlos Elementary 18.0 138092.575000 48904.466735 11095.54 127227.7100 138932.845 156218.1600 238839.36
South San Francisco Unified 30.0 129668.000000 46964.351686 0.00 103666.2500 142952.000 158681.0000 225309.00
Bayshore Elementary 4.0 108459.750000 63718.933190 54525.00 56265.7500 97654.000 149848.0000 184006.00
La Honda-Pescadero Unified 6.0 106035.880000 31954.599811 50338.65 94916.7175 117095.025 123246.0425 138866.25
count mean std min 25% 50% 75% max
Agency
Hillsborough City Elementary 9.0 180800.321111 48691.111731 89546.44 178676.1300 188815.960 201455.0000 253150.62
San Mateo Union High 35.0 179364.508857 51950.716830 83158.91 157897.6050 184304.040 212086.1450 330816.69
Las Lomitas Elementary 12.0 164175.263333 52042.128677 64807.13 138380.9825 179541.060 195614.1725 235632.38
San Mateo-Foster City 39.0 163547.648462 40346.017049 55680.49 151279.9800 182760.170 188471.5800 209969.37
Burlingame Elementary 15.0 163290.935333 55282.291789 60098.64 153580.7350 163974.680 183922.6650 300712.30
Woodside Elementary 8.0 152223.303750 62430.850119 96975.96 102800.2800 148727.360 165407.8750 287480.51
San Carlos Elementary 16.0 151139.110625 40843.867221 65947.53 135040.6975 150910.715 163008.6725 246861.84
Menlo Park City Elementary 20.0 146769.108500 72683.671468 1320.89 84959.9125 166267.175 200791.6950 269385.57
Pacifica School District 16.0 143586.615000 51778.175134 49589.52 117958.8625 148467.150 170896.6250 237194.10
Redwood City Elementary 39.0 140820.036923 44175.732482 14975.72 131887.5450 152557.360 164632.1350 223152.08
Belmont-Redwood Shores Elementary 17.0 140485.691176 61757.174462 1480.75 138942.9800 164994.560 173561.0400 233844.88
South San Francisco Unified 32.0 132642.315625 37510.743848 37939.40 124617.1875 143527.350 151413.0875 205408.48
Jefferson Elementary 32.0 132317.989687 47399.814655 11055.74 110352.5350 150614.295 156865.3800 244588.82
La Honda-Pescadero Unified 5.0 130490.516000 10691.324150 118325.88 122842.1300 129516.800 136776.0200 144991.75
Cabrillo Unified 20.0 126984.943000 37431.220189 57603.29 96715.6525 134913.920 147660.6125 200071.38
Millbrae Elementary 14.0 114471.565000 51463.792234 48777.38 61762.2275 123167.405 152566.8975 185831.11
Bayshore Elementary 4.0 85788.060000 34855.370881 56680.98 61627.8075 76491.225 100651.4775 133488.81
count mean std min 25% 50% 75% max
Agency
Hillsborough City Elementary 9.0 181169.812222 31783.703017 111214.08 177599.6500 179517.220 192084.6100 230110.31
San Mateo Union High 34.0 179583.057353 63800.059716 67855.19 146944.3225 193358.545 214268.9650 349292.66
San Mateo County Office of Education 15.0 171824.753333 42039.612935 112399.23 154657.7250 160899.900 192750.1500 269154.10
Las Lomitas Elementary 11.0 169416.515455 36724.891355 87928.76 157297.4750 180683.390 184717.9050 222583.06
Portola Valley Elementary 6.0 154655.211667 68101.011995 43745.94 119738.8350 181106.540 197847.6250 219261.33
Burlingame Elementary 14.0 147353.475714 46239.626580 85085.58 128919.5100 150926.520 160606.8800 269387.20
Menlo Park City Elementary 17.0 144489.420588 53016.319870 21375.38 127400.9000 156662.770 175083.7300 237957.52
San Mateo-Foster City 44.0 142133.094545 51832.366683 3285.24 138346.9900 159025.190 164019.5050 295265.20
Pacifica School District 15.0 142035.239333 48802.133605 54837.09 123938.6050 152575.980 162585.1250 229580.87
Belmont-Redwood Shores Elementary 14.0 135555.767143 43988.694104 62544.65 117238.4250 143240.910 152731.1800 230557.28
Redwood City Elementary 43.0 129560.791860 48787.557498 863.21 120327.9500 144624.910 157269.1350 229521.57
Ravenswood City Elementary 22.0 124625.576364 35159.635501 64941.02 115191.4250 133356.900 139483.5275 219733.88
Jefferson Elementary 32.0 118060.531875 48631.019374 10085.22 76929.2675 138715.010 143836.4400 225706.35
San Carlos Elementary 15.0 116900.909333 22790.031382 72134.56 108930.3300 117762.960 124632.1100 171667.00
Jefferson Union High 30.0 114744.606000 53042.964687 489.14 73619.1825 131492.345 149925.6300 225689.78
La Honda-Pescadero Unified 5.0 109192.750000 8997.909133 100878.14 101856.1700 105995.600 116063.5300 121170.31
San Bruno Park Elementary 12.0 97827.477500 27878.938228 30670.58 86900.5400 103920.205 106481.0400 147856.33
Millbrae Elementary 15.0 96670.515333 62496.138707 328.69 49454.3200 94317.800 142291.3000 209097.50
Brisbane Elementary 6.0 86987.401667 66854.664255 2191.88 50682.9275 79517.390 112352.6450 196328.58
count mean std min 25% 50% 75% max
Agency
San Mateo Union High 29.0 174610.090345 37343.996983 65133.59 163524.1000 178442.240 187430.0400 258306.10
Menlo Park City Elementary 13.0 152274.036154 55485.917033 18852.54 143425.0600 150900.460 185098.2100 245983.71
Las Lomitas Elementary 10.0 151517.413000 51373.593400 23094.62 151314.2200 166578.730 175308.2250 213357.76
Hillsborough City Elementary 11.0 149780.548182 45589.322120 82671.33 117504.3050 164223.510 175083.0150 228250.83
Sequoia Union High 21.0 149521.128095 59225.921590 5816.90 142494.6200 166466.970 183608.1100 253867.20
San Mateo County Office of Education 16.0 147809.639375 56417.206718 29261.07 107509.1250 151154.515 185551.1375 240595.31
San Mateo-Foster City 36.0 145454.551111 36159.075157 58301.25 138502.5100 150877.105 155011.2175 282214.43
Woodside Elementary 6.0 138135.421667 67761.076844 41176.92 100659.1150 145226.730 168350.5550 235320.41
Pacifica School District 13.0 137986.120000 40797.000920 48149.41 124462.5800 136397.320 155031.4900 211025.07
Burlingame Elementary 12.0 130820.462500 57985.228145 52437.15 78320.5275 145302.760 151915.6550 250942.90
South San Francisco Unified 34.0 127547.124118 29951.534336 54590.37 117912.6800 125232.950 140487.0625 226915.94
Jefferson Elementary 27.0 124934.866296 27088.220443 50362.61 115391.3850 124849.650 135243.3550 202870.52
Jefferson Union High 24.0 119422.918333 32177.159461 34969.11 104889.8425 119926.770 134103.1350 202264.92
San Carlos Elementary 15.0 119201.788667 45586.651523 28793.78 95778.9050 132528.300 139505.6700 216285.71
Ravenswood City Elementary 24.0 118728.525417 35708.234624 43308.32 104135.2550 124797.545 141064.1900 177308.07
Belmont-Redwood Shores Elementary 19.0 118533.848947 38676.604849 66349.20 87152.7200 114703.600 144310.9300 219341.77
Redwood City Elementary 42.0 116009.933333 38733.863109 34401.89 84208.4700 124649.430 145017.4075 222483.60
Bayshore Elementary 2.0 114167.580000 1071.691038 113409.78 113788.6800 114167.580 114546.4800 114925.38
Millbrae Elementary 12.0 104993.597500 55724.134015 30219.41 49558.5625 125105.885 129884.4700 208543.22
Brisbane Elementary 4.0 104810.077500 74776.691374 19635.50 69039.4025 99802.460 135573.1350 199999.89
Portola Valley Elementary 5.0 97005.250000 56071.151727 32480.14 86928.9500 89070.580 89070.5800 187476.00
Cabrillo Unified 23.0 92846.356957 58925.935493 132.00 48843.6150 99992.670 139522.1700 212956.80
La Honda-Pescadero Unified 4.0 92784.332500 13539.533237 80864.83 86600.2900 89011.255 95195.2975 112249.99
count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 3.0 196362.470000 18333.603175 182528.68 185965.1700 189401.660 203279.3650 217157.07
Woodside Elementary 3.0 175041.876667 45183.765210 138713.16 149744.4200 160775.680 193206.2350 225636.79
San Mateo Union High 30.0 173871.018667 39811.625978 42959.22 159690.7925 178330.425 187605.5600 256250.04
Sequoia Union High 13.0 166950.480769 36371.650572 89080.97 146889.6300 173254.390 182101.4500 247151.76
San Mateo County Office of Education 13.0 155722.933077 37554.853919 80678.60 140504.7900 160898.330 175217.8700 225169.08
Menlo Park City Elementary 12.0 153029.810000 44490.769543 77499.89 128323.1050 160746.950 179149.7675 239775.73
Burlingame Elementary 11.0 137997.866364 49220.679172 53570.02 138168.4200 139949.190 152714.2400 235077.69
Hillsborough City Elementary 12.0 134573.834167 47211.217664 60812.68 92941.5950 151601.880 161392.7175 221387.78
Millbrae Elementary 9.0 133744.924444 38292.601909 57249.90 125513.5500 132357.430 148152.9000 200738.98
Belmont-Redwood Shores Elementary 16.0 131621.450625 42031.476511 57996.80 102749.7650 143481.645 158409.8775 204954.78
Jefferson Elementary 23.0 120422.289130 27386.568416 37805.39 111583.6000 119928.130 128084.1850 193615.91
Ravenswood City Elementary 20.0 113298.292500 33958.727390 23336.36 101309.1850 117317.070 124494.3450 195853.86
South San Francisco Unified 35.0 112020.050286 34741.471399 44560.16 98284.9750 117120.980 130195.5500 208827.57
Las Lomitas Elementary 13.0 110235.785385 48377.669536 16877.43 78674.1800 106692.600 156093.4000 171198.28
San Mateo-Foster City 36.0 110072.339722 35378.775796 34513.53 105150.9425 119372.875 122299.4775 234083.11
San Carlos Elementary 15.0 109776.440000 52289.832169 3403.92 102270.4950 121359.870 133254.8500 213404.86
Bayshore Elementary 2.0 108843.265000 1063.594665 108091.19 108467.2275 108843.265 109219.3025 109595.34
Jefferson Union High 31.0 90777.020968 37540.635744 11790.66 58088.4100 94270.920 116867.3550 188310.28
La Honda-Pescadero Unified 7.0 77049.857143 33199.203870 11674.89 69059.8250 85020.750 98251.7650 108030.18